WorkstationTaxHistory

Entity Definition

Logical Name : WorkstationTaxHistory
Physical Name : LE_HST_WS_TX

A collection of tax totals for a tax authority by workstation for a reporting period.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TaxGroupRuleID (FK)(PK) System assigned unique identifier for the TaxGroupRule. ID_RU_TX_GRP Identity integer TaxRateRule(RU_TX_RT)
WorkstationID (FK)(PK) The unique identifier for the WORKSTATION, typically the serial number. ID_WS Identity integer WorkstationHistory(LE_HST_WS)
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer WorkstationHistory(LE_HST_WS)
TaxRateRuleSequenceNumber (FK)(PK) A squential number for theTaxRateRule, denoting the order of creation of the rules. AI_TX_RT_RU LineNumber smallint TaxRateRule(RU_TX_RT)
TaxCollectedTotalAmount The total monetary amount of tax collected by WORKSTATION for each REPORTING PERIOD. CP_TX_CLT_TOT Money decimal(16,5)
TaxableSaleTotalAmount The total monetary amount of taxable sales by WORKSTATION for each REPORTING PERIOD. CP_SLS_TX_TOT Money decimal(16,5)
TaxExemptSaleTotalAmount The total monetary amount of tax exempt sales by WORKSTATION for each REPORTING PERIOD. CP_SLS_TX_EXM_TOT Money decimal(16,5)
TaxExemptTransactionCount The total number of tax exempt transactions by WORKSTATION for each REPORTING PERIOD. QU_TRN_TX_EXM QuantityTransactionCount decimal(7,0)

Relationships

Parent Entity Verb Phrase Child Entity
WorkstationHistory includes WorkstationTaxHistory
TaxRateRule is summarized in WorkstationTaxHistory

Logical Views containing WorkstationTaxHistory

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 03120 - Reporting - Store Operations - Period View
Logical 03140 - Reporting - Store Operations - Workstation View
Logical 05000 - Taxation - Macro View
Logical 05400 - Taxation - Reporting View - Tax Rule Reference